<?php
namespace console\controllers;

use yii;
use yii\console\Controller;

/**
 * busy_operator_report_zip_schedule_3
 * busy_operator_zip_schedule_2
 * 手工对
 * @author mayn
 *
 */
class CheckController extends Controller
{
    public $tables = [

        //玉洋begin
//         'busy_operator_zip_schedule_3',
//         'busy_financial_habadinfov2',
//         'busy_limu_zhifubao',
//         'busy_limu_zhimafen',
//         'busy_limu_new_mx_tao',
//         'busy_limu_new_tao',
//         'busy_limu_new_zhifubao',
//         'busy_limu_tao',
//         'busy_limu_tokens',
//         'busy_financial_creditstatus',
//         'busy_authorized_token_status',
//         'busy_push_message',
//         'busy_push_log',
//         'busy_role_logs',
//         'busy_sh_tencentdata_config',
//         'busy_transaction_list',
//         'busy_notice',
        //玉洋end
        
        
        'busy_pay_sh_config',
        'busy_finance_offline_write_off_apply',
        'busy_finance_offline_write_off_audit',
        'busy_member_accural_auto',
        'busy_fengkong_own_model',
        'busy_decision_usertables',
        'busy_statistics_back',
        'busy_statistics_expense',
        'busy_admin_recharge',
        'busy_admin_credit_record',
        'busy_miguan',
        'busy_decision_rule_risk3',
        'busy_decision_rule_seruity',
        'busy_decision_rule_wdrisklist',
        'busy_decision_rule_xyapply',
        'busy_decision_rule_xycredit',
        'busy_operator',
        
        //'busy_operator_report_zip_schedule_2',
        //'busy_limu_new_credit',
        //'busy_operator_report_zip_old',
        //'busy_member_sdf',
        //'busy_decision_logs',
        //'busy_financial_panoramicradar',
        //'busy_financial_washblack',
        //'busy_card_encrypt',
        //'busy_member_yun_status',
        //'busy_bank_verify',
//         'busy_operator_report_zip',
//         'busy_admin_allot_renew',
//         'busy_admin_allot_supplement',
//         'busy_pay_channel_bind_card',
//         'busy_member_edit_record',
//         'busy_operator_report_zip_schedule_3',
        
        //闫雄
//         'busy_operator_zip_schedule_2',
        'busy_admin_add_transaction',
        'busy_admin_product',
        'busy_admin_transaction_extension',
        'busy_admin_wechat',
        'busy_admin_youdun',
        'busy_decision_rules',
        
        'busy_admin_return_channel',
        'busy_decision_ruleses',
        'busy_decision_type',
//         'busy_feedback',
        'busy_file',
        'busy_notice_log',
         
        'busy_recharge',
       
        'busy_admin_credit_config',
//         'busy_admin_link_share',
        'busy_decision_rule_education',
        'busy_decision_rule_fund',
        'busy_decision_rule_invest',
        'busy_decision_rule_jd',
        'busy_decision_scorecard',
        'busy_chaxun_order',
        //'busy_member',
        'busy_admin_assign_logs',
        'busy_expense',
        'busy_operator_report_zip_schedule_3',
        'busy_operator_zip_schedule_2',
        'busy_app_status',
        
        //乔艳荣
//         'busy_operator_report_zip_schedule_1',
//         'busy_add_tran_logs',
//         'busy_link_share_right',
//         'busy_sign_bank',
//         'busy_purviews',
//         'busy_admin_user_base',
//         'busy_system_connector',
//         'busy_admin_user_apply',
//         'busy_link_share_warning_notice',
//         'busy_page_view',
//         'busy_operator_zip',
//         'busy_admin_user',
//         'busy_admin_allot_borrow',
//         'busy_admin_allot_config',
//         'busy_admin_allot_logs',
//         'busy_admin_allot_overdue',
//         'busy_admin_allot_performance',

        //马永昌
        'busy_operator_zip_schedule_0',
        'busy_member_mark',
        'busy_user_lifting_amount',
        'busy_tran_mark',
        'busy_other_expense',
        'busy_open_model_list',
        'busy_send_set',
        'busy_offline_member',
        'busy_admin_auto_loan',
        'busy_member_contract',
        'busy_decision_rule_xydefault',
        'busy_member_total',
        'busy_member_preloan',
        'busy_member_group',

        /*
        //安帅
        'busy_operator_zip_schedule_6',
        'busy_operator_report_zip_schedule_0',
        'busy_decision_rule_risk1',
        'busy_decision_rule_risk2',
        'busy_decision_rule_tao',
        'busy_decision_rule_user',
        'busy_decision_rule_xybehavior',
        'busy_decision_rule_yun',
        'busy_member_vocation',
        'busy_member_phone',
        'busy_member_linkman',
        'busy_member_export_record',
        'busy_member_potential_logs',
        'busy_message_list',
        'busy_fengkong_model',
        'busy_delegate_task',
        
        //冯子超
        'busy_operator_report_zip_schedule_2',
        'busy_limu_new_credit',
        'busy_operator_report_zip_old',
        'busy_member_sdf',
        'busy_decision_logs',
        'busy_financial_panoramicradar',
        'busy_financial_washblack',
        'busy_card_encrypt',
        'busy_member_yun_status',
        'busy_bank_verify',
        'busy_operator_report_zip',
        'busy_admin_allot_renew',
        'busy_admin_allot_supplement',
//         'busy_pay_channel_bind_card',
//         'busy_pay_channel_bind_card',
        'busy_member_edit_record',
        
        //郭林
        'busy_operator_report_zip_schedule_4',
        'busy_financial_panoramicradar_two',
        'busy_financial_youdun_compare',
        'busy_report_process',
        'busy_cuishoufen_res',
        'busy_financial_credityuqi',
        'busy_operator_data',
        'busy_member_related',
        'busy_financial_face',
        'busy_financial_facecheck',
        'busy_financial_gerentxcx',
        
        //韩志浩
        'busy_operator_zip_schedule_4',
        'busy_member_info',
        'busy_member_img',
        'busy_member_data',
        'busy_member_base',
        'busy_bank_info',
        'busy_bigdata_loan',
        'busy_financial_applyradar',
        'busy_financial_behaviorradar',
        'busy_financial_compare',
        'busy_phone_black',
        'busy_admin_data',
        'busy_admin_data',
        'busy_admin_manage',
        'busy_analysis_auditor',
        'busy_analysis_borrower',
        
        //贺丹平
        'busy_operator_zip_schedule_1',
        'busy_feedback' ,
        'busy_statistics_expense_type',
        'busy_statistics_register',
        'busy_lianlian_order',
        'busy_loan_record',
        'busy_member_accural',
        'busy_member',
        'busy_member_apply_extension',
        'busy_member_bank',
        'busy_member_call_log',
        'busy_operator_report_zip',
        'busy_admin_link_share',
        'busy_member_cishu',
        'busy_member_boos',
        'busy_decision_lines',
        'busy_decision_rule_creditbill',
        'busy_decision_rule_creditreport',
        'busy_member_other',
        
        //严雅丽
        'busy_operator_zip_schedule_5',
        
         'busy_consume_price',
         'busy_develop_menu',
         'busy_develop_route',
         'busy_file_class',
         'busy_grouping',
         'busy_admin_group',
         'busy_moblie_price',
         'busy_model_area',
         'busy_pay_type',
         'busy_operator_tag_type',
         'busy_operator_name',
         'busy_operator_tag',
         'busy_promote_models',
         'busy_sms_model',
         'busy_unit',
         'busy_mobile_belonging',
         'busy_decision_table_field',
         'busy_the_problem',
         'busy_other',
        
        'busy_analysis_collection',
        'busy_financial_statistics',
        'busy_analysis_service',
        'busy_loan_over',
        'busy_member_export_log',
        
        //贺军远
        'busy_operator_report_zip_schedule_6',
        'busy_financial_modelscore',
        'busy_financial_risklist',
        'busy_gengduo_tupian',
        'busy_huadao',
        'busy_idnamecheck_info',
        'busy_idnamecheck_info_log',
        'busy_idnamephonecheck_info',
        'busy_idnamephonecheck_info_log',
        'busy_limu_credit',
        'busy_limu_didi',
        'busy_limu_education',
        'busy_limu_fund',
        'busy_limu_group_report',
        'busy_limu_jd',
        'busy_limu_jiedaibao',
        'busy_limu_jinjiedao',
        'busy_limu_new_fund',
        'busy_limu_new_jd',
        'busy_limu_new_shebao',
        'busy_limu_new_yanghang',
        'busy_limu_new_yun',

        //王琬熙
        'busy_operator_report_zip_schedule_5',
        'busy_limu_qqtxl',
        'busy_limu_shebao',
        'busy_limu_yanghang',
        'busy_member_antifraud',
        'busy_member_antifraud_tokenkey',
        'busy_member_consult',
        'busy_member_coordinate',
        'busy_member_invite',
        'busy_member_model_score',
        'busy_member_order',
        'busy_preloan',
        'busy_report_gzip',
        'busy_report_nofee_gzip',
        'busy_service',
        'busy_operator_excel_gzip',
        'busy_operator_gzip',
        'busy_system_logs',
        'busy_tongdun',
        'busy_xindaizhenghe',
        'busy_yun_wait',
        'busy_yun_wait_report',
        'busy_limu_mifang',
        */
        
    ];
    
    //统计总库
    public $master = [

        'busy_pay_sh_config' => "SELECT count(*) as count FROM busy_pay_sh_config WHERE admin_id = :admin_id",
        
        'busy_finance_offline_write_off_apply' => "SELECT count(*) as count FROM busy_finance_offline_write_off_apply WHERE sh_id = :admin_id",
        
        'busy_finance_offline_write_off_audit' => "SELECT count(*) as count FROM busy_finance_offline_write_off_audit WHERE sh_id = :admin_id",
        
        'busy_member_accural_auto'=>"SELECT count(*) as count FROM busy_member_accural_auto WHERE admin_id =:admin_id",
        
        'busy_fengkong_own_model' => "SELECT count(*) as count FROM busy_fengkong_own_model WHERE admin_id = :admin_id",
        
        'busy_decision_usertables' => "SELECT count(*) as count FROM busy_decision_usertables WHERE admin_id = :admin_id",
        
        'busy_statistics_back' => "SELECT count(*) as count FROM busy_statistics_back WHERE admin_id = :admin_id",
        
        'busy_statistics_expense' => "SELECT count(*) as count FROM busy_statistics_expense WHERE admin_id =:admin_id",
        
        'busy_admin_recharge' => "SELECT count(*) as count FROM busy_admin_recharge WHERE admin_id = :admin_id",
        
        'busy_admin_credit_record' => "SELECT count(*) as count FROM busy_admin_credit_record WHERE admin_id = :admin_id",
        
        'busy_miguan' => "SELECT count(a.id) as count FROM busy_miguan a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id= :admin_id",
        
        'busy_decision_rule_risk3' => "SELECT count(a.id) as count FROM busy_decision_rule_risk3 a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id= :admin_id",
        
        'busy_decision_rule_seruity' => "SELECT count(a.id) as count FROM busy_decision_rule_seruity a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id= :admin_id",
        
        'busy_decision_rule_wdrisklist' => "SELECT count(a.id) as count FROM busy_decision_rule_wdrisklist a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id= :admin_id",
        
        'busy_decision_rule_xyapply' => "SELECT count(a.id) as count FROM busy_decision_rule_xyapply a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
        
        'busy_decision_rule_xycredit' => "SELECT count(a.id) as count FROM busy_decision_rule_xycredit a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
        
        'busy_operator' => "SELECT count(a.id) as count FROM busy_operator a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        
        //德峰
        'busy_limu_new_credit' => "SELECT count(a.id) as count FROM busy_limu_new_credit a LEFT JOIN busy_member  b on a.userid=b.id where b.admin_id= :admin_id",
        
        'busy_operator_report_zip_old' => "SELECT count(a.id) as count FROM busy_operator_report_zip_old a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id = :admin_id",
        
        'busy_member_sdf' => "SELECT count(a.id) as count FROM busy_member_sdf a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id = :admin_id",
        
        'busy_decision_logs' => "SELECT count(a.id) as count FROM busy_decision_logs a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        
        'busy_financial_panoramicradar' => "SELECT count(a.id) as count FROM busy_financial_panoramicradar a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        
        'busy_financial_washblack' => "SELECT count(a.id) as count FROM busy_financial_washblack a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        
        'busy_card_encrypt' => "SELECT count(a.id) as count FROM busy_card_encrypt a LEFT JOIN busy_member b on a.user_id=b.id where b.admin_id=:admin_id",
        
        'busy_member_yun_status' => "SELECT count(a.id) as count FROM busy_member_yun_status a LEFT JOIN busy_member b on a.user_id=b.id where b.admin_id=:admin_id",
        
        'busy_bank_verify' => "SELECT count(a.id) as count FROM busy_bank_verify a LEFT JOIN busy_member  b on a.userid=b.id where b.admin_id=:admin_id",
        
        'busy_operator_report_zip' => "SELECT count(a.id) as count FROM busy_operator_report_zip a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        
        'busy_admin_allot_renew' => "SELECT count(*) as count FROM busy_admin_allot_renew WHERE admin_id=:admin_id",
        
        'busy_admin_allot_supplement' => "SELECT count(*) as count FROM busy_admin_allot_supplement WHERE admin_id=:admin_id",
        
        'busy_pay_channel_bind_card' => "SELECT count(*) as count FROM busy_pay_channel_bind_card WHERE admin_id=:admin_id",
        
        //'busy_admin_allot_renew' => "SELECT * FROM busy_pay_channel_bind_card WHERE sh_id=:admin_id",
        
        'busy_member_edit_record' => "SELECT count(*) as count FROM busy_member_edit_record WHERE admin_id=:admin_id",
        
        //闫雄
        'busy_admin_add_transaction' => "SELECT count(*) as count FROM busy_admin_add_transaction WHERE admin_id = :admin_id",

        'busy_admin_product' => "SELECT count(*) as count FROM busy_admin_product WHERE admin_id =:admin_id",

        //'busy_admin_transaction_extension' => "SELECT count(*) as count FROM busy_admin_transaction_extension WHERE admin_id = :admin_id",
        
        'busy_admin_transaction_extension' => "SELECT count(*) as count FROM busy_admin_transaction_extension WHERE admin_id in (select id from busy_admin_user where cid = :admin_id) or admin_id = :admin_id",
        
        'busy_admin_wechat' => "SELECT count(*) as count FROM busy_admin_wechat WHERE admin_id = :admin_id",

        'busy_admin_youdun' => "SELECT count(*) as count FROM busy_admin_youdun WHERE admin_id = :admin_id",

        'busy_decision_rules' => "SELECT count(*) as count FROM busy_decision_rules WHERE admin_id =:admin_id",

        'busy_admin_return_channel' => "SELECT count(*) as count FROM busy_admin_return_channel WHERE admin_id =:admin_id",

        'busy_decision_ruleses' => "SELECT count(*) as count FROM busy_decision_ruleses WHERE admin_id =:admin_id",

        'busy_decision_type' => "SELECT count(*) as count FROM busy_decision_type WHERE admin_id =:admin_id",

        'busy_feedback' => "SELECT count(*) as count FROM busy_feedback WHERE admin_id =:admin_id",

        'busy_file' => "SELECT count(*) as count FROM busy_file WHERE userid=:admin_id",

        'busy_notice_log' => "SELECT count(*) as count FROM busy_notice_log WHERE user_id = :admin_id",

        'busy_expense' => "SELECT count(*) as count FROM busy_expense WHERE userid =:admin_id",

        'busy_recharge' => "SELECT count(*) as count FROM busy_recharge WHERE admin_id =:admin_id",

        'busy_admin_credit_config' => "SELECT count(*) as count FROM busy_admin_credit_config WHERE admin_id = :admin_id",

        'busy_admin_link_share' => "SELECT count(*) as count FROM busy_admin_link_share WHERE userid = :admin_id",
        
        'busy_decision_rule_education' => "SELECT count(a.id) as count  FROM busy_decision_rule_education a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id ",
        'busy_decision_rule_fund' => "SELECT count(a.id) as count  FROM busy_decision_rule_fund a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id ",
        'busy_decision_rule_invest' => "SELECT count(a.id) as count  FROM busy_decision_rule_invest a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id ",
        'busy_decision_rule_jd' => "SELECT count(a.id) as count  FROM busy_decision_rule_jd a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id ",
        'busy_decision_scorecard' => "SELECT count(a.id) as count  FROM busy_decision_scorecard a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id ",
        'busy_chaxun_order' => "SELECT count(a.id) as count  FROM busy_chaxun_order a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id ",
        
        'busy_app_status' => 'select count(*) as count from busy_app_status where admin_id = :admin_id',
        
        //第四部分

        'busy_member' => "SELECT count(*) as count FROM busy_member WHERE admin_id=:admin_id",
    
        'busy_admin_assign_logs' => "select count(*) as count from busy_admin_assign_logs where businesses = :admin_id",
        
        'busy_operator_report_zip_schedule_3' => "SELECT count(a.id) as count FROM busy_operator_report_zip_schedule_3 a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        
        'busy_operator_zip_schedule_2' => "SELECT count(a.id) as count FROM busy_operator_zip_schedule_2 a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
 
        //补充表，特殊处理，不能放开
        //'busy_admin_transaction_extension' => "SELECT count(*) as count FROM busy_admin_transaction_extension WHERE admin_id in (select id from busy_admin_user where cid = :admin_id)",
  
        //玉洋
        'busy_financial_habadinfov2'=>"SELECT count(a.id) as count FROM busy_financial_habadinfov2 a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_limu_zhifubao'=>"SELECT count(a.id) as count FROM busy_limu_zhifubao a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_limu_zhimafen'=>"SELECT count(a.id) as count FROM busy_limu_zhimafen a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_limu_new_mx_tao'=>"SELECT count(a.id) as count FROM busy_limu_new_mx_tao a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_limu_new_tao'=>"SELECT count(a.id) as count FROM busy_limu_new_tao a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_limu_new_zhifubao'=>"SELECT count(a.id) as count FROM busy_limu_new_zhifubao a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_limu_tao'=>"SELECT count(a.id) as count FROM busy_limu_tao a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_limu_tokens'=>"SELECT count(a.id) as count FROM busy_limu_tokens a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_financial_creditstatus'=>"SELECT count(a.id) as count FROM busy_financial_creditstatus a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_authorized_token_status'=>"SELECT count(a.id) as count FROM busy_authorized_token_status a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        
        'busy_push_message'=>"SELECT count(*) as count FROM busy_push_message WHERE admin_id=:admin_id",
        'busy_push_log'=>"SELECT count(*) as count FROM busy_push_log WHERE admin_id=:admin_id",
        'busy_role_logs'=>"SELECT count(*) as count FROM busy_role_logs WHERE admin_id=:admin_id",
        'busy_sh_tencentdata_config'=>"SELECT count(*) as count FROM busy_sh_tencentdata_config WHERE sh_id=:admin_id",
        'busy_transaction_list'=>"SELECT count(*) as count FROM busy_transaction_list WHERE admin_id=:admin_id",
        'busy_notice'=>"SELECT count(a.id) as count FROM busy_notice a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        
        'busy_operator_zip_schedule_3' => "SELECT count(a.id) as count FROM busy_operator_zip_schedule_3 a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",

        //乔艳荣
        'busy_operator_report_zip_schedule_1'=>"SELECT count(a.id) as count FROM busy_operator_report_zip_schedule_1 a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        
        'busy_add_tran_logs'=>"SELECT count(a.id) as count FROM busy_add_tran_logs a LEFT JOIN busy_admin_add_transaction b on a.tid = b.id where b.admin_id=:admin_id",
        
        'busy_link_share_right'=>"SELECT count(a.id) as count FROM busy_link_share_right a LEFT JOIN busy_admin_link_share b on a.link_share_id = b.id where b.userid=:admin_id",
        
        'busy_sign_bank'=>"SELECT count(a.id) as count FROM busy_sign_bank  a left JOIN busy_member_bank b on a.bid = b.id WHERE b.admin_id = :admin_id",
        
        //'busy_purviews'=>"SELECT count(a.id) as count FROM busy_purviews a LEFT JOIN busy_admin_user b on a.weichat_id =b.weichat_id WHERE b.cid =:admin_id or b.id=:admin_id group by id",
        
        'busy_purviews'=>"select count(t.id) as count from (SELECT a.* FROM busy_purviews a LEFT JOIN busy_admin_user b on a.weichat_id =b.weichat_id WHERE b.cid =:admin_id or b.id=:admin_id group by id) as t",

        'busy_admin_user_base'=>"SELECT count(a.id) as count FROM busy_admin_user_base a left JOIN busy_admin_user b on a.id = b.id WHERE b.id = :admin_id or b.cid =:admin_id",
        
        'busy_system_connector'=>"SELECT count(b.id) as count from busy_admin_user a left join busy_system_connector b on a.weichat_id = b.var where b.var IS not null and a.id = :admin_id",
        
        'busy_admin_user_apply'=>"SELECT count(a.id) as count FROM busy_admin_user_apply a LEFT JOIN busy_admin_user b ON a.userid=b.id where b.cid = :admin_id or b.id=:admin_id",
        
        'busy_link_share_warning_notice'=>"SELECT count(b.id) as count FROM  busy_admin_link_share a left JOIN busy_link_share_warning_notice b on b.share_id = a.id WHERE a.userid = :admin_id",
        
        'busy_page_view'=>"SELECT count(b.id) as count from busy_admin_user a left join busy_page_view b on a.weichat_id = b.wechat_id where b.wechat_id IS not null and a.id = :admin_id",
        
        'busy_operator_zip'=>"SELECT count(a.id) as count FROM busy_operator_zip a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        
        'busy_admin_user'=>"SELECT count(*) as count from busy_admin_user where id = :admin_id or cid = :admin_id",
        
        'busy_admin_allot_borrow'=>"SELECT count(*) as count FROM busy_admin_allot_borrow WHERE admin_id=:admin_id",
        
        'busy_admin_allot_config'=>"SELECT count(*) as count FROM busy_admin_allot_config WHERE admin_id=:admin_id",
        
        'busy_admin_allot_logs'=>"SELECT count(*) as count FROM busy_admin_allot_logs WHERE admin_id=:admin_id",
        
        'busy_admin_allot_overdue'=>"SELECT count(*) as count FROM busy_admin_allot_overdue WHERE admin_id=:admin_id",
        
        'busy_admin_allot_performance'=>"SELECT count(*) as count FROM busy_admin_allot_performance WHERE admin_id=:admin_id",
  
        //马永昌
        'busy_operator_zip_schedule_0'=>"SELECT count(a.id) as count FROM busy_operator_zip_schedule_0 a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_member_mark'=>"SELECT count(a.id) as count from busy_member_mark a left join busy_member m on a.userid=m.id where m.admin_id=:admin_id",
        'busy_user_lifting_amount'=>"SELECT count(*) as count FROM busy_user_lifting_amount WHERE admin_id =:admin_id",
        'busy_tran_mark'=>"SELECT count(*) as count FROM busy_tran_mark WHERE admin_id=:admin_id",
        'busy_other_expense'=>"SELECT count(*) as count FROM busy_other_expense WHERE userid = :admin_id",
        'busy_open_model_list'=>"SELECT count(*) as count FROM busy_open_model_list WHERE admin_id =:admin_id",
        'busy_send_set'=>"SELECT count(*) as count FROM busy_send_set WHERE admin_id =:admin_id",
        'busy_offline_member'=>"SELECT count(*) as count FROM busy_offline_member WHERE userid =:admin_id",
        'busy_admin_auto_loan'=>"SELECT count(*) as count FROM busy_admin_auto_loan WHERE admin_id=:admin_id",
        'busy_member_contract'=>"SELECT count(a.id) as count FROM busy_member_contract a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_decision_rule_xydefault'=>"SELECT count(a.id) as count FROM busy_decision_rule_xydefault a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
        'busy_member_total'=>"SELECT count(a.id) as count FROM busy_member_total a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
        'busy_member_preloan'=>"SELECT count(a.id) as count FROM busy_member_preloan a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
        'busy_member_group'=>"SELECT count(a.id) as count FROM busy_member_group a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
    
        //安帅
        'busy_operator_zip_schedule_6' => "SELECT count(a.id) as count FROM busy_operator_zip_schedule_6 a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_operator_report_zip_schedule_0' => "SELECT count(a.id) as count FROM busy_operator_report_zip_schedule_0 a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_decision_rule_risk1' => "SELECT count(a.id) as count FROM busy_decision_rule_risk1 a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
        'busy_decision_rule_risk2' => "SELECT count(a.id) as count FROM busy_decision_rule_risk2 a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
        'busy_decision_rule_tao' => "SELECT count(a.id) as count FROM busy_decision_rule_tao a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
        'busy_decision_rule_user' => "SELECT count(a.id) as count FROM busy_decision_rule_user a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
        'busy_decision_rule_xybehavior' => "SELECT count(a.id) as count FROM busy_decision_rule_xybehavior a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
        'busy_decision_rule_yun' => "SELECT count(a.id) as count FROM busy_decision_rule_yun a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
        'busy_member_vocation' => "SELECT count(a.id) as count FROM busy_member_vocation a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
        'busy_member_phone' => "SELECT count(a.id) as count FROM busy_member_phone a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
        'busy_member_linkman' => "SELECT count(a.id) as count FROM busy_member_linkman a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
        'busy_member_export_record' => "SELECT count(*) as count FROM busy_member_export_record WHERE admin_id=:admin_id",
        'busy_member_potential_logs' => "SELECT count(*) as count FROM busy_member_potential_logs WHERE admin_id=:admin_id",
        'busy_message_list' => "SELECT count(*) as count FROM busy_message_list WHERE admin_id=:admin_id",
        'busy_fengkong_model' => "SELECT count(*) as count FROM busy_fengkong_model WHERE admin_id=:admin_id",
        'busy_delegate_task' => "SELECT count(*) as count FROM busy_delegate_task WHERE admin_id=:admin_id",
        
        //冯子超
        'busy_operator_report_zip_schedule_2' => "SELECT count(a.id) as count FROM busy_operator_report_zip_schedule_2 a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_limu_new_credit' => "SELECT count(a.id) as count FROM busy_limu_new_credit a LEFT JOIN busy_member  b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_operator_report_zip_old' => "SELECT count(a.id) as count FROM busy_operator_report_zip_old a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_member_sdf' => "SELECT count(a.id) as count FROM busy_member_sdf a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_decision_logs' => "SELECT count(a.id) as count FROM busy_decision_logs a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_financial_panoramicradar' => "SELECT count(a.id) as count FROM busy_financial_panoramicradar a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_financial_washblack' => "SELECT count(a.id) as count FROM busy_financial_washblack a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_card_encrypt' => "SELECT count(a.id) as count FROM busy_card_encrypt a LEFT JOIN busy_member b on a.user_id=b.id where b.admin_id=:admin_id",
        'busy_member_yun_status' => "SELECT count(a.id) as count FROM busy_member_yun_status a LEFT JOIN busy_member b on a.user_id=b.id where b.admin_id=:admin_id",
        'busy_bank_verify' => "SELECT count(a.id) as count FROM busy_bank_verify a LEFT JOIN busy_member  b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_operator_report_zip' => "SELECT count(a.id) as count FROM busy_operator_report_zip a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_admin_allot_renew' => "SELECT count(*) as count FROM busy_admin_allot_renew WHERE admin_id=:admin_id",
        'busy_admin_allot_supplement' => "SELECT count(*) as count FROM busy_admin_allot_supplement WHERE admin_id=:admin_id",
        'busy_pay_channel_bind_card' => "SELECT count(*) as count FROM busy_pay_channel_bind_card WHERE admin_id=:admin_id",
        'busy_pay_channel_bind_card' => "SELECT count(*) as count FROM busy_pay_channel_bind_card WHERE sh_id=:admin_id",
        'busy_member_edit_record' => "SELECT count(*) as count FROM busy_member_edit_record WHERE admin_id=:admin_id",
        
        //郭林
        'busy_operator_report_zip_schedule_4' => "SELECT count(a.id) as count FROM busy_operator_report_zip_schedule_4 a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_financial_panoramicradar_two' => "SELECT count(a.id) as count FROM busy_financial_panoramicradar_two a LEFT JOIN busy_member  b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_financial_youdun_compare' => "SELECT count(a.id) as count FROM busy_financial_youdun_compare a LEFT JOIN busy_member  b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_report_process' => "SELECT count(a.id) as count FROM busy_report_process a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_cuishoufen_res' => "SELECT count(a.id) as count FROM busy_cuishoufen_res a LEFT JOIN busy_member b on a.user_id=b.id where b.admin_id=:admin_id",
        'busy_financial_credityuqi' => "SELECT count(a.id) as count FROM busy_financial_credityuqi a LEFT JOIN busy_member  b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_operator_data' => "SELECT count(a.id) as count FROM busy_operator_data a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_member_related' => "SELECT count(a.id) as count FROM busy_member_related a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_financial_face' => "SELECT count(a.id) as count FROM busy_financial_face a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_financial_facecheck' => "SELECT count(a.id) as count FROM busy_financial_facecheck a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_financial_gerentxcx' => "SELECT count(a.id) as count FROM busy_financial_gerentxcx a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        
        //韩志浩
        'busy_operator_zip_schedule_4' => "SELECT count(a.id) as count FROM busy_operator_zip_schedule_4 a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_member_info' => "SELECT count(a.id) as count FROM busy_member_info a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
        'busy_member_img' => "SELECT count(a.id) as count FROM busy_member_img a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
        'busy_member_data' => "SELECT count(a.id) as count FROM busy_member_data a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
        'busy_member_base' => "SELECT count(a.id) as count FROM busy_member_base a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
        'busy_bank_info' => "SELECT count(a.id) as count FROM busy_bank_info a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_bigdata_loan' => "SELECT count(a.id) as count FROM busy_bigdata_loan a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_financial_applyradar' => "SELECT count(a.id) as count FROM busy_financial_applyradar a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_financial_behaviorradar' => "SELECT count(a.id) as count FROM busy_financial_behaviorradar a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_financial_compare' => "SELECT count(a.id) as count FROM busy_financial_compare a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_phone_black' => "SELECT count(a.id) as count FROM busy_phone_black  a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_admin_data' => "SELECT count(a.id) as count FROM busy_admin_data a left JOIN busy_member b on a.userid = a.id WHERE b.admin_id = :admin_id",
        'busy_admin_data' => "SELECT count(*) as count FROM busy_admin_data WHERE userid = :admin_id",
        'busy_admin_manage' => "SELECT count(*) as count FROM busy_admin_manage WHERE admin_id=:admin_id",
        'busy_analysis_auditor' => "SELECT count(*) as count FROM busy_analysis_auditor WHERE admin_id=:admin_id",
        'busy_analysis_borrower' => "SELECT count(*) as count FROM busy_analysis_borrower WHERE admin_id=:admin_id",
        
        //贺丹平
        'busy_operator_zip_schedule_1' => "SELECT count(a.id) as count FROM busy_operator_zip_schedule_1 a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_feedback' => "SELECT count(*) as count FROM busy_feedback WHERE admin_id =:admin_id",
        'busy_statistics_expense_type' => "SELECT count(*) as count FROM busy_statistics_expense_type WHERE admin_id =:admin_id",
        'busy_statistics_register' => "SELECT count(*) as count FROM busy_statistics_register WHERE admin_id =:admin_id",
        'busy_lianlian_order' => "SELECT count(*) as count FROM busy_lianlian_order WHERE admin_id =:admin_id",
        'busy_loan_record' => "SELECT count(*) as count FROM busy_loan_record WHERE admin_id =:admin_id",
        'busy_member_accural' => "SELECT count(*) as count FROM busy_member_accural WHERE admin_id =:admin_id",
        'busy_member' => "SELECT count(*) as count FROM busy_member WHERE admin_id =:admin_id",
        'busy_member_apply_extension' => "SELECT count(*) as count FROM busy_member_apply_extension WHERE admin_id =:admin_id",
        'busy_member_bank' => "SELECT count(*) as count FROM busy_member_bank WHERE admin_id =:admin_id",
        'busy_member_call_log' => "SELECT count(*) as count FROM busy_member_call_log WHERE admin_id =:admin_id",
        'busy_operator_report_zip' => "SELECT count(a.id) as count FROM busy_operator_report_zip a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_admin_link_share' => "SELECT count(*) as count FROM busy_admin_link_share WHERE userid =:admin_id",
        'busy_member_cishu' => "SELECT count(a.id) as count FROM busy_member_cishu a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
        'busy_member_boos' => "SELECT count(a.id) as count FROM busy_member_boos a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
        'busy_decision_lines' => "SELECT count(a.id) as count FROM busy_decision_lines a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
        'busy_decision_rule_creditbill' => "SELECT count(a.id) as count FROM busy_decision_rule_creditbill a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
        'busy_decision_rule_creditreport' => "SELECT count(a.id) as count FROM busy_decision_rule_creditreport a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
        'busy_member_other' => "SELECT count(a.id) as count FROM busy_member_other a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        
        //严雅丽
        'busy_operator_zip_schedule_5' => "SELECT count(a.id) as count FROM busy_operator_zip_schedule_5 a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        
        'busy_consume_price' => "select count(*) as count from busy_consume_price where :admin_id",
        'busy_develop_menu' => "select count(*) as count from busy_develop_menu where :admin_id",
        'busy_develop_route' => "select count(*) as count from busy_develop_route where :admin_id",
        'busy_file_class' => "select count(*) as count from busy_file_class where :admin_id",
        'busy_grouping' => "select count(*) as count from busy_grouping where :admin_id",
        'busy_admin_group' => "select count(*) as count from busy_admin_group where :admin_id",
        'busy_moblie_price' => "select count(*) as count from busy_moblie_price where :admin_id",
        'busy_model_area' => "select count(*) as count from busy_model_area where :admin_id",
        'busy_pay_type' => "select count(*) as count from busy_pay_type where :admin_id",
        'busy_operator_tag_type' => "select count(*) as count from busy_operator_tag_type where :admin_id",
        'busy_operator_name' => "select count(*) as count from busy_operator_name where :admin_id",
        'busy_operator_tag' => "select count(*) as count from busy_operator_tag where :admin_id",
        'busy_promote_models' => "select count(*) as count from busy_promote_models where :admin_id",
        'busy_sms_model' => "select count(*) as count from busy_sms_model where :admin_id",
        'busy_unit' => "select count(*) as count from busy_unit where :admin_id",
        'busy_mobile_belonging' => "select count(*) as count from busy_mobile_belonging where :admin_id",
        'busy_decision_table_field' => "select count(*) as count from busy_decision_table_field where :admin_id",
        'busy_the_problem' => "select count(*) as count from busy_the_problem where :admin_id",
        'busy_other' => "select count(*) as count from busy_other where :admin_id",
        
        'busy_analysis_collection' => "SELECT count(*) as count FROM busy_analysis_collection WHERE admin_id=:admin_id",
        'busy_financial_statistics' => "SELECT count(*) as count FROM busy_financial_statistics WHERE admin_id=:admin_id",
        'busy_analysis_service' => "SELECT count(*) as count FROM busy_analysis_service WHERE admin_id=:admin_id",
        'busy_loan_over' => "SELECT count(*) as count FROM busy_loan_over WHERE admin_id=:admin_id",
        'busy_member_export_log' => "SELECT count(*) as count FROM busy_member_export_log WHERE admin_id=:admin_id",
        
        //贺军远
        'busy_operator_report_zip_schedule_6' => "SELECT count(a.id) as count FROM busy_operator_report_zip_schedule_6 a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_financial_modelscore' => "SELECT count(a.id) as count FROM busy_financial_modelscore a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_financial_risklist' => "SELECT count(a.id) as count FROM busy_financial_risklist a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_gengduo_tupian' => "SELECT count(a.id) as count FROM busy_gengduo_tupian a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_huadao' => "SELECT count(a.id) as count FROM busy_huadao a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_idnamecheck_info' => "SELECT count(a.id) as count FROM busy_idnamecheck_info a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_idnamecheck_info_log' => "SELECT count(a.id) as count FROM busy_idnamecheck_info_log a LEFT JOIN busy_member b on a.userId=b.id WHERE b.admin_id=:admin_id",
        'busy_idnamephonecheck_info' => "SELECT count(a.id) as count FROM busy_idnamephonecheck_info a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_idnamephonecheck_info_log' => "SELECT count(a.id) as count FROM busy_idnamephonecheck_info_log a LEFT JOIN busy_member b on a.userId=b.id WHERE b.admin_id=:admin_id",
        'busy_limu_credit' => "SELECT count(a.id) as count FROM busy_limu_credit a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_limu_didi' => "SELECT count(a.id) as count FROM busy_limu_didi a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_limu_education' => "SELECT count(a.id) as count FROM busy_limu_education a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_limu_fund' => "SELECT count(a.id) as count FROM busy_limu_fund a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_limu_group_report' => "SELECT count(a.id) as count FROM busy_limu_group_report a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_limu_jd' => "SELECT count(a.id) as count FROM busy_limu_jd a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_limu_jiedaibao' => "SELECT count(a.id) as count FROM busy_limu_jiedaibao a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_limu_jinjiedao' => "SELECT count(a.id) as count FROM busy_limu_jinjiedao a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_limu_new_fund' => "SELECT count(a.id) as count FROM busy_limu_new_fund a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_limu_new_jd' => "SELECT count(a.id) as count FROM busy_limu_new_jd a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_limu_new_shebao' => "SELECT count(a.id) as count FROM busy_limu_new_shebao a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_limu_new_yanghang' => "SELECT count(a.id) as count FROM busy_limu_new_yanghang a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_limu_new_yun' => "SELECT count(a.id) as count FROM busy_limu_new_yun a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        
        //王琬熙
        'busy_operator_report_zip_schedule_5' => "SELECT count(a.id) as count FROM busy_operator_report_zip_schedule_5 a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_limu_qqtxl' => "SELECT count(a.id) as count FROM busy_limu_qqtxl a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_limu_shebao' => "SELECT count(a.id) as count FROM busy_limu_shebao a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_limu_yanghang' => "SELECT count(a.id) as count FROM busy_limu_yanghang a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_member_antifraud' => "SELECT count(a.id) as count FROM busy_member_antifraud a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_member_antifraud_tokenkey' => "SELECT count(a.id) as count FROM busy_member_antifraud_tokenkey a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_member_consult' => "SELECT count(a.id) as count FROM busy_member_consult a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_member_coordinate' => "SELECT count(a.id) as count FROM busy_member_coordinate a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_member_invite' => "SELECT count(a.id) as count FROM busy_member_invite a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_member_model_score' => "SELECT count(a.id) as count FROM busy_member_model_score a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_member_order' => "SELECT count(a.id) as count FROM busy_member_order a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_preloan' => "SELECT count(a.id) as count FROM busy_preloan a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_report_gzip' => "SELECT count(a.id) as count FROM busy_report_gzip a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_report_nofee_gzip' => "SELECT count(a.id) as count FROM busy_report_nofee_gzip a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_service' => "SELECT count(a.id) as count FROM busy_service a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_operator_excel_gzip' => "SELECT count(a.id) as count FROM busy_operator_excel_gzip a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_operator_gzip' => "SELECT count(a.id) as count FROM busy_operator_gzip a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_system_logs' => "SELECT count(a.id) as count FROM busy_system_logs a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_tongdun' => "SELECT count(a.id) as count FROM busy_tongdun a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_xindaizhenghe' => "SELECT count(a.id) as count FROM busy_xindaizhenghe a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_yun_wait' => "SELECT count(a.id) as count FROM busy_yun_wait a LEFT JOIN busy_member b on a.user_id=b.id WHERE b.admin_id=:admin_id",
        'busy_yun_wait_report' => "SELECT count(a.id) as count FROM busy_yun_wait_report a LEFT JOIN busy_member b on a.user_id=b.id WHERE b.admin_id=:admin_id",
        'busy_limu_mifang' => "SELECT count(a.id) as count FROM busy_limu_mifang a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
         
    ];
    
    
    public $migrate = [
        'busy_pay_sh_config' => "SELECT * FROM busy_pay_sh_config WHERE admin_id = :admin_id",
        
        'busy_finance_offline_write_off_apply' => "SELECT * FROM busy_finance_offline_write_off_apply WHERE sh_id =:admin_id",
        
        'busy_finance_offline_write_off_audit' => "SELECT * FROM busy_finance_offline_write_off_audit WHERE sh_id =:admin_id",
        
        'busy_member_accural_auto' => "SELECT * FROM busy_member_accural_auto WHERE admin_id =:admin_id",
        
        'busy_fengkong_own_model' => "SELECT * FROM busy_fengkong_own_model WHERE admin_id =:admin_id",
        
        'busy_decision_usertables' => "SELECT * FROM busy_decision_usertables WHERE admin_id =:admin_id",
        
        'busy_statistics_back' => "SELECT * FROM busy_statistics_back WHERE admin_id =:admin_id",
        
        'busy_statistics_expense' => "SELECT * FROM busy_statistics_expense WHERE admin_id =:admin_id",
        
        'busy_admin_recharge' => "SELECT * FROM busy_admin_recharge WHERE admin_id = :admin_id",
        
        'busy_admin_credit_record' => "SELECT * FROM busy_admin_credit_record WHERE admin_id = :admin_id",
        
        'busy_miguan' => "SELECT a.* FROM busy_miguan a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",

        'busy_decision_rule_risk3' => "SELECT a.* FROM busy_decision_rule_risk3 a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
        
        'busy_decision_rule_xyapply' => "SELECT a.* FROM busy_decision_rule_xyapply a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
        
        'busy_operator' => "SELECT a.* FROM busy_operator a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        
        'busy_decision_rule_xycredit' => "SELECT a.* FROM busy_decision_rule_xycredit a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
        
        'busy_admin_product' => "SELECT * FROM busy_admin_product WHERE admin_id =:admin_id",
        
        //'busy_admin_transaction_extension' => "SELECT * FROM busy_admin_transaction_extension WHERE admin_id = :admin_id",
        
        'busy_admin_transaction_extension' => "SELECT * FROM busy_admin_transaction_extension WHERE admin_id in (select id from busy_admin_user where cid = :admin_id) or admin_id = :admin_id",
        
        
        //闫雄
        'busy_admin_add_transaction' => "SELECT * FROM busy_admin_add_transaction WHERE admin_id = :admin_id",
        
        'busy_admin_wechat' => "SELECT * FROM busy_admin_wechat WHERE admin_id = :admin_id",
        
        'busy_admin_youdun' => "SELECT * FROM busy_admin_youdun WHERE admin_id = :admin_id",
        
        'busy_decision_rules' => "SELECT * FROM busy_decision_rules WHERE admin_id =:admin_id",
        
        'busy_admin_return_channel' => "SELECT * FROM busy_admin_return_channel WHERE admin_id =:admin_id",
        
        'busy_decision_ruleses' => "SELECT * FROM busy_decision_ruleses WHERE admin_id =:admin_id",
        
        'busy_decision_type' => "SELECT * FROM busy_decision_type WHERE admin_id =:admin_id",
        
//         'busy_feedback' => "SELECT * FROM busy_feedback WHERE admin_id =:admin_id",//有人操作
        
        'busy_file' => "SELECT * FROM busy_file WHERE userid=:admin_id",
        
        'busy_notice_log' => "SELECT * FROM busy_notice_log WHERE user_id = :admin_id",
        
        'busy_expense' => "SELECT * FROM busy_expense WHERE userid =:admin_id",//手工导出
               
        'busy_admin_credit_config' => "SELECT * FROM busy_admin_credit_config WHERE admin_id = :admin_id",
        
        'busy_recharge' => "SELECT * FROM busy_recharge WHERE admin_id =:admin_id",
        
        'busy_decision_rule_jd' => "SELECT a.* FROM busy_decision_rule_jd a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
        
        'busy_decision_rule_education' => "SELECT a.* FROM busy_decision_rule_education a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
        
//         'busy_admin_link_share' => "SELECT * FROM busy_admin_link_share WHERE userid = :admin_id",//有人操作

        'busy_app_status' => 'select * from busy_app_status where admin_id = :admin_id',
        
        //第四部分
        'busy_member_sdf' => "SELECT a.* FROM busy_member_sdf a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        
        'busy_decision_logs' => "SELECT a.* FROM busy_decision_logs a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        
        'busy_financial_panoramicradar' => "SELECT a.* FROM busy_financial_panoramicradar a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        
        'busy_financial_washblack' => "SELECT a.* FROM busy_financial_washblack a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
    
        'busy_card_encrypt' => "SELECT a.* FROM busy_card_encrypt a LEFT JOIN busy_member b on a.user_id=b.id where b.admin_id=:admin_id",
    
        'busy_member_yun_status' => "SELECT a.* FROM busy_member_yun_status a LEFT JOIN busy_member b on a.user_id=b.id where b.admin_id=:admin_id",
        
        //'busy_member' => "SELECT * FROM busy_member WHERE admin_id=:admin_id",
        
        'busy_admin_assign_logs' => "select * from busy_admin_assign_logs where businesses = :admin_id",
        
//         'busy_operator_report_zip_schedule_3' => "SELECT count(a.id) as count FROM busy_operator_report_zip_schedule_3 a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        
//         'busy_operator_zip_schedule_2' => "SELECT count(a.id) as count FROM busy_operator_zip_schedule_2 a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        
        'busy_operator_report_zip_schedule_3' => "SELECT a.* FROM busy_operator_report_zip_schedule_3 a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        
        'busy_operator_zip_schedule_2' => "SELECT a.* FROM busy_operator_zip_schedule_2 a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        
        //补充表，特殊执行不能放开
        //'busy_admin_transaction_extension' => "SELECT * FROM busy_admin_transaction_extension WHERE admin_id in (select id from busy_admin_user where cid = :admin_id)",
        
        
        //玉洋
        'busy_operator_zip_schedule_3'=>"SELECT a.* FROM busy_operator_zip_schedule_3 a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_financial_habadinfov2'=>"SELECT a.* FROM busy_financial_habadinfov2 a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_limu_zhifubao'=>"SELECT a.* FROM busy_limu_zhifubao a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_limu_zhimafen'=>"SELECT a.* FROM busy_limu_zhimafen a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_limu_new_mx_tao'=>"SELECT a.* FROM busy_limu_new_mx_tao a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_limu_new_tao'=>"SELECT a.* FROM busy_limu_new_tao a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_limu_new_zhifubao'=>"SELECT a.* FROM busy_limu_new_zhifubao a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_limu_tao'=>"SELECT a.* FROM busy_limu_tao a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_limu_tokens'=>"SELECT a.* FROM busy_limu_tokens a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_financial_creditstatus'=>"SELECT a.* FROM busy_financial_creditstatus a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_authorized_token_status'=>"SELECT a.* FROM busy_authorized_token_status a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_push_message'=>"SELECT * FROM busy_push_message WHERE admin_id=:admin_id",
        'busy_push_log'=>"SELECT * FROM busy_push_log WHERE admin_id=:admin_id",
        'busy_role_logs'=>"SELECT * FROM busy_role_logs WHERE admin_id=:admin_id",
        'busy_sh_tencentdata_config'=>"SELECT * FROM busy_sh_tencentdata_config WHERE sh_id=:admin_id",
        'busy_transaction_list'=>"SELECT * FROM busy_transaction_list WHERE admin_id=:admin_id",
        'busy_notice'=>"SELECT a.* FROM busy_notice a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        
        //乔艳荣
        'busy_operator_report_zip_schedule_1'=>"SELECT a.* FROM busy_operator_report_zip_schedule_1 a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_add_tran_logs'=>"SELECT a.* FROM busy_add_tran_logs a LEFT JOIN busy_admin_add_transaction b on a.tid = b.id where b.admin_id=:admin_id",
        'busy_link_share_right'=>"SELECT a.* FROM busy_link_share_right a LEFT JOIN busy_admin_link_share b on a.link_share_id = b.id where b.userid=:admin_id",
        'busy_sign_bank'=>"SELECT a.* FROM busy_sign_bank  a left JOIN busy_member_bank b on a.bid = b.id WHERE b.admin_id = :admin_id",
        'busy_purviews'=>"SELECT a.* FROM busy_purviews a LEFT JOIN busy_admin_user b on a.weichat_id =b.weichat_id WHERE b.cid =:admin_id or b.id=:admin_id group by id",
        'busy_admin_user_base'=>"SELECT a.* FROM busy_admin_user_base a left JOIN busy_admin_user b on a.id = b.id WHERE b.id = :admin_id or b.cid =:admin_id",
        
        'busy_system_connector'=>"SELECT b.* from busy_admin_user a left join busy_system_connector b on a.weichat_id = b.var where b.var IS not null and a.id = :admin_id",
        'busy_admin_user_apply'=>"SELECT a.* FROM busy_admin_user_apply a LEFT JOIN busy_admin_user b ON a.userid=b.id where b.cid = :admin_id or b.id=:admin_id",

        'busy_link_share_warning_notice'=>"SELECT b.* FROM  busy_admin_link_share a left JOIN busy_link_share_warning_notice b on b.share_id = a.id WHERE a.userid = :admin_id",
        'busy_page_view'=>"SELECT b.* from busy_admin_user a left join busy_page_view b on a.weichat_id = b.wechat_id where b.wechat_id IS not null and a.id = :admin_id",
        'busy_operator_zip'=>"SELECT a.* FROM busy_operator_zip a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        
        'busy_admin_user'=>"SELECT * from busy_admin_user where id = :admin_id or cid = :admin_id",
        
        'busy_admin_allot_borrow'=>"SELECT * FROM busy_admin_allot_borrow WHERE admin_id=:admin_id",
        'busy_admin_allot_config'=>"SELECT * FROM busy_admin_allot_config WHERE admin_id=:admin_id",
        'busy_admin_allot_logs'=>"SELECT * FROM busy_admin_allot_logs WHERE admin_id=:admin_id",
        'busy_admin_allot_overdue'=>"SELECT * FROM busy_admin_allot_overdue WHERE admin_id=:admin_id",
        'busy_admin_allot_performance'=>"SELECT * FROM busy_admin_allot_performance WHERE admin_id=:admin_id",
        
        //马永昌
        'busy_operator_zip_schedule_0' => "SELECT a.* FROM busy_operator_zip_schedule_0 a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_member_mark' => "SELECT a.* from busy_member_mark a left join busy_member m on a.userid=m.id where m.admin_id=:admin_id",
        'busy_user_lifting_amount' => "SELECT * FROM busy_user_lifting_amount WHERE admin_id =:admin_id",
        'busy_tran_mark' => "SELECT * FROM busy_tran_mark WHERE admin_id=:admin_id",
        'busy_other_expense' => "SELECT * FROM busy_other_expense WHERE userid = :admin_id",
        'busy_open_model_list' => "SELECT * FROM busy_open_model_list WHERE admin_id =:admin_id",
        'busy_send_set' => "SELECT * FROM busy_send_set WHERE admin_id =:admin_id",
        'busy_offline_member' => "SELECT * FROM busy_offline_member WHERE userid =:admin_id",
        'busy_admin_auto_loan' => "SELECT * FROM busy_admin_auto_loan WHERE admin_id=:admin_id",
        'busy_member_contract' => "SELECT a.* FROM busy_member_contract a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        
        'busy_decision_rule_xydefault' => "SELECT a.* FROM busy_decision_rule_xydefault a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
        'busy_member_total' => "SELECT a.* FROM busy_member_total a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
        'busy_member_preloan' => "SELECT a.* FROM busy_member_preloan a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
        'busy_member_group' => "SELECT a.* FROM busy_member_group a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",

        //安帅
        'busy_operator_zip_schedule_6' => "SELECT a.* FROM busy_operator_zip_schedule_6 a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_operator_report_zip_schedule_0' => "SELECT a.* FROM busy_operator_report_zip_schedule_0 a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_decision_rule_risk1' => "SELECT a.* FROM busy_decision_rule_risk1 a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
        'busy_decision_rule_risk2' => "SELECT a.* FROM busy_decision_rule_risk2 a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
        'busy_decision_rule_tao' => "SELECT a.* FROM busy_decision_rule_tao a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
        'busy_decision_rule_user' => "SELECT a.* FROM busy_decision_rule_user a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
        'busy_decision_rule_xybehavior' => "SELECT a.* FROM busy_decision_rule_xybehavior a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
        'busy_decision_rule_yun' => "SELECT a.* FROM busy_decision_rule_yun a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
        'busy_member_vocation' => "SELECT a.* FROM busy_member_vocation a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
        'busy_member_phone' => "SELECT a.* FROM busy_member_phone a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
        'busy_member_linkman' => "SELECT a.* FROM busy_member_linkman a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
        'busy_member_export_record' => "SELECT * FROM busy_member_export_record WHERE admin_id=:admin_id",
        'busy_member_potential_logs' => "SELECT * FROM busy_member_potential_logs WHERE admin_id=:admin_id",
        'busy_message_list' => "SELECT * FROM busy_message_list WHERE admin_id=:admin_id",
        'busy_fengkong_model' => "SELECT * FROM busy_fengkong_model WHERE admin_id=:admin_id",
        'busy_delegate_task' => "SELECT * FROM busy_delegate_task WHERE admin_id=:admin_id",
    
        //冯子超
        'busy_operator_report_zip_schedule_2' => "SELECT a.* FROM busy_operator_report_zip_schedule_2 a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_limu_new_credit' => "SELECT a.* FROM busy_limu_new_credit a LEFT JOIN busy_member  b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_operator_report_zip_old' => "SELECT a.* FROM busy_operator_report_zip_old a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_member_sdf' => "SELECT a.* FROM busy_member_sdf a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_decision_logs' => "SELECT a.* FROM busy_decision_logs a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_financial_panoramicradar' => "SELECT a.* FROM busy_financial_panoramicradar a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_financial_washblack' => "SELECT a.* FROM busy_financial_washblack a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_card_encrypt' => "SELECT a.* FROM busy_card_encrypt a LEFT JOIN busy_member b on a.user_id=b.id where b.admin_id=:admin_id",
        'busy_member_yun_status' => "SELECT a.* FROM busy_member_yun_status a LEFT JOIN busy_member b on a.user_id=b.id where b.admin_id=:admin_id",
        'busy_bank_verify' => "SELECT a.* FROM busy_bank_verify a LEFT JOIN busy_member  b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_operator_report_zip' => "SELECT a.* FROM busy_operator_report_zip a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_admin_allot_renew' => "SELECT * FROM busy_admin_allot_renew WHERE admin_id=:admin_id",
        'busy_admin_allot_supplement' => "SELECT * FROM busy_admin_allot_supplement WHERE admin_id=:admin_id",
        'busy_pay_channel_bind_card' => "SELECT * FROM busy_pay_channel_bind_card WHERE admin_id=:admin_id",
        'busy_pay_channel_bind_card' => "SELECT * FROM busy_pay_channel_bind_card WHERE sh_id=:admin_id",
        'busy_member_edit_record' => "SELECT * FROM busy_member_edit_record WHERE admin_id=:admin_id",
        
        //郭林
        'busy_operator_report_zip_schedule_4' => "SELECT a.* FROM busy_operator_report_zip_schedule_4 a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_financial_panoramicradar_two' => "SELECT a.* FROM busy_financial_panoramicradar_two a LEFT JOIN busy_member  b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_financial_youdun_compare' => "SELECT a.* FROM busy_financial_youdun_compare a LEFT JOIN busy_member  b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_report_process' => "SELECT a.* FROM busy_report_process a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_cuishoufen_res' => "SELECT a.* FROM busy_cuishoufen_res a LEFT JOIN busy_member b on a.user_id=b.id where b.admin_id=:admin_id",
        'busy_financial_credityuqi' => "SELECT a.* FROM busy_financial_credityuqi a LEFT JOIN busy_member  b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_operator_data' => "SELECT a.* FROM busy_operator_data a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_member_related' => "SELECT a.* FROM busy_member_related a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_financial_face' => "SELECT a.* FROM busy_financial_face a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_financial_facecheck' => "SELECT a.* FROM busy_financial_facecheck a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_financial_gerentxcx' => "SELECT a.* FROM busy_financial_gerentxcx a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",

        //韩志浩
        'busy_operator_zip_schedule_4' => "SELECT a.* FROM busy_operator_zip_schedule_4 a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_member_info' => "SELECT a.* FROM busy_member_info a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
        'busy_member_img' => "SELECT a.* FROM busy_member_img a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
        'busy_member_data' => "SELECT a.* FROM busy_member_data a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
        'busy_member_base' => "SELECT a.* FROM busy_member_base a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
        'busy_bank_info' => "SELECT a.* FROM busy_bank_info a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_bigdata_loan' => "SELECT a.* FROM busy_bigdata_loan a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_financial_applyradar' => "SELECT a.* FROM busy_financial_applyradar a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_financial_behaviorradar' => "SELECT a.* FROM busy_financial_behaviorradar a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_financial_compare' => "SELECT a.* FROM busy_financial_compare a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_phone_black' => "SELECT a.* FROM busy_phone_black  a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_admin_data' => "SELECT a.* FROM busy_admin_data a left JOIN busy_member b on a.userid = a.id WHERE b.admin_id = :admin_id",
        'busy_admin_data' => "SELECT * FROM busy_admin_data WHERE userid = :admin_id",
        'busy_admin_manage' => "SELECT * FROM busy_admin_manage WHERE admin_id=:admin_id",
        'busy_analysis_auditor' => "SELECT * FROM busy_analysis_auditor WHERE admin_id=:admin_id",
        'busy_analysis_borrower' => "SELECT * FROM busy_analysis_borrower WHERE admin_id=:admin_id",
        
        //贺丹平
        'busy_operator_zip_schedule_1' => "SELECT a.* FROM busy_operator_zip_schedule_1 a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_feedback' => "SELECT * FROM busy_feedback WHERE admin_id =:admin_id",
        'busy_statistics_expense_type' => "SELECT * FROM busy_statistics_expense_type WHERE admin_id =:admin_id",
        'busy_statistics_register' => "SELECT * FROM busy_statistics_register WHERE admin_id =:admin_id",
        'busy_lianlian_order' => "SELECT * FROM busy_lianlian_order WHERE admin_id =:admin_id",
        'busy_loan_record' => "SELECT * FROM busy_loan_record WHERE admin_id =:admin_id",
        'busy_member_accural' => "SELECT * FROM busy_member_accural WHERE admin_id =:admin_id",
        'busy_member' => "SELECT * FROM busy_member WHERE admin_id =:admin_id",
        'busy_member_apply_extension' => "SELECT * FROM busy_member_apply_extension WHERE admin_id =:admin_id",
        'busy_member_bank' => "SELECT * FROM busy_member_bank WHERE admin_id =:admin_id",
        'busy_member_call_log' => "SELECT * FROM busy_member_call_log WHERE admin_id =:admin_id",
        'busy_operator_report_zip' => "SELECT a.* FROM busy_operator_report_zip a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_admin_link_share' => "SELECT * FROM busy_admin_link_share WHERE userid =:admin_id",
        'busy_member_cishu' => "SELECT a.* FROM busy_member_cishu a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
        'busy_member_boos' => "SELECT a.* FROM busy_member_boos a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
        'busy_decision_lines' => "SELECT a.* FROM busy_decision_lines a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
        'busy_decision_rule_creditbill' => "SELECT a.* FROM busy_decision_rule_creditbill a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
        'busy_decision_rule_creditreport' => "SELECT a.* FROM busy_decision_rule_creditreport a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id",
        'busy_member_other' => "SELECT a.* FROM busy_member_other a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        
        //严雅丽
        'busy_operator_zip_schedule_5' => "SELECT a.* FROM busy_operator_zip_schedule_5 a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        
        'busy_consume_price' => "select * from busy_consume_price where :admin_id",
        'busy_develop_menu' => "select * from busy_develop_menu where :admin_id",
        'busy_develop_route' => "select * from busy_develop_route where :admin_id",
        'busy_file_class' => "select * from busy_file_class where :admin_id",
        'busy_grouping' => "select * from busy_grouping where :admin_id",
        'busy_admin_group' => "select * from busy_admin_group where :admin_id",
        'busy_moblie_price' => "select * from busy_moblie_price where :admin_id",
        'busy_model_area' => "select * from busy_model_area where :admin_id",
        'busy_pay_type' => "select * from busy_pay_type where :admin_id",
        'busy_operator_tag_type' => "select * from busy_operator_tag_type where :admin_id",
        'busy_operator_name' => "select * from busy_operator_name where :admin_id",
        'busy_operator_tag' => "select * from busy_operator_tag where :admin_id",
        'busy_promote_models' => "select * from busy_promote_models where :admin_id",
        'busy_sms_model' => "select * from busy_sms_model where :admin_id",
        'busy_unit' => "select * from busy_unit where :admin_id",
        'busy_mobile_belonging' => "select * from busy_mobile_belonging where :admin_id",
        'busy_decision_table_field' => "select * from busy_decision_table_field where :admin_id",
        'busy_the_problem' => "select * from busy_the_problem where :admin_id",
        'busy_other' => "select * from busy_other where :admin_id",

        'busy_analysis_collection' => "SELECT * FROM busy_analysis_collection WHERE admin_id=:admin_id",
        'busy_financial_statistics' => "SELECT * FROM busy_financial_statistics WHERE admin_id=:admin_id",
        'busy_analysis_service' => "SELECT * FROM busy_analysis_service WHERE admin_id=:admin_id",
        'busy_loan_over' => "SELECT * FROM busy_loan_over WHERE admin_id=:admin_id",
        'busy_member_export_log' => "SELECT * FROM busy_member_export_log WHERE admin_id=:admin_id",
        
        //贺军远
        'busy_operator_report_zip_schedule_6' => "SELECT a.* FROM busy_operator_report_zip_schedule_6 a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_financial_modelscore' => "SELECT a.* FROM busy_financial_modelscore a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_financial_risklist' => "SELECT a.* FROM busy_financial_risklist a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_gengduo_tupian' => "SELECT a.* FROM busy_gengduo_tupian a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_huadao' => "SELECT a.* FROM busy_huadao a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_idnamecheck_info' => "SELECT a.* FROM busy_idnamecheck_info a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_idnamecheck_info_log' => "SELECT a.* FROM busy_idnamecheck_info_log a LEFT JOIN busy_member b on a.userId=b.id WHERE b.admin_id=:admin_id",
        'busy_idnamephonecheck_info' => "SELECT a.* FROM busy_idnamephonecheck_info a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_idnamephonecheck_info_log' => "SELECT a.* FROM busy_idnamephonecheck_info_log a LEFT JOIN busy_member b on a.userId=b.id WHERE b.admin_id=:admin_id",
        'busy_limu_credit' => "SELECT a.* FROM busy_limu_credit a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_limu_didi' => "SELECT a.* FROM busy_limu_didi a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_limu_education' => "SELECT a.* FROM busy_limu_education a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_limu_fund' => "SELECT a.* FROM busy_limu_fund a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_limu_group_report' => "SELECT a.* FROM busy_limu_group_report a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_limu_jd' => "SELECT a.* FROM busy_limu_jd a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_limu_jiedaibao' => "SELECT a.* FROM busy_limu_jiedaibao a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_limu_jinjiedao' => "SELECT a.* FROM busy_limu_jinjiedao a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_limu_new_fund' => "SELECT a.* FROM busy_limu_new_fund a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_limu_new_jd' => "SELECT a.* FROM busy_limu_new_jd a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_limu_new_shebao' => "SELECT a.* FROM busy_limu_new_shebao a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_limu_new_yanghang' => "SELECT a.* FROM busy_limu_new_yanghang a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_limu_new_yun' => "SELECT a.* FROM busy_limu_new_yun a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        
        //王琬熙
        'busy_operator_report_zip_schedule_5' => "SELECT a.* FROM busy_operator_report_zip_schedule_5 a LEFT JOIN busy_member b on a.userid=b.id where b.admin_id=:admin_id",
        'busy_limu_qqtxl' => "SELECT a.* FROM busy_limu_qqtxl a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_limu_shebao' => "SELECT a.* FROM busy_limu_shebao a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_limu_yanghang' => "SELECT a.* FROM busy_limu_yanghang a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_member_antifraud' => "SELECT a.* FROM busy_member_antifraud a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_member_antifraud_tokenkey' => "SELECT a.* FROM busy_member_antifraud_tokenkey a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_member_consult' => "SELECT a.* FROM busy_member_consult a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_member_coordinate' => "SELECT a.* FROM busy_member_coordinate a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_member_invite' => "SELECT a.* FROM busy_member_invite a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_member_model_score' => "SELECT a.* FROM busy_member_model_score a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_member_order' => "SELECT a.* FROM busy_member_order a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_preloan' => "SELECT a.* FROM busy_preloan a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_report_gzip' => "SELECT a.* FROM busy_report_gzip a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_report_nofee_gzip' => "SELECT a.* FROM busy_report_nofee_gzip a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_service' => "SELECT a.* FROM busy_service a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_operator_excel_gzip' => "SELECT a.* FROM busy_operator_excel_gzip a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_operator_gzip' => "SELECT a.* FROM busy_operator_gzip a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_system_logs' => "SELECT a.* FROM busy_system_logs a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_tongdun' => "SELECT a.* FROM busy_tongdun a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_xindaizhenghe' => "SELECT a.* FROM busy_xindaizhenghe a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        'busy_yun_wait' => "SELECT a.* FROM busy_yun_wait a LEFT JOIN busy_member b on a.user_id=b.id WHERE b.admin_id=:admin_id",
        'busy_yun_wait_report' => "SELECT a.* FROM busy_yun_wait_report a LEFT JOIN busy_member b on a.user_id=b.id WHERE b.admin_id=:admin_id",
        'busy_limu_mifang' => "SELECT a.* FROM busy_limu_mifang a LEFT JOIN busy_member b on a.userid=b.id WHERE b.admin_id=:admin_id",
        
    ];
    

    //数秒借
//     public $admin_id = 2500;

    //猪猪侠
//     public $admin_id = 117644;
    
    //领钱花
//     public $admin_id = 117786;

    //金借贝
//     public $admin_id = 115286;
    
    //金元宝
//     public $admin_id = 117651;

    //酷爱钱包 这儿
//     public $admin_id = 114738;

    //宜贷钱包
//     public $admin_id = 115211;

    //无忧贷 
//     public $admin_id = 118750;

    //秒出米
//     public $admin_id = 115255;

    //速秒花 
//     public $admin_id = 118522;

    
//     钱易拿 
//     public $admin_id = 113420;

    //芒果花花 商户id 112655
//     public $admin_id = 112655;

    //金豆
//     public $admin_id = 615;
    
    //易宁钱包
//     public $admin_id = 116882;

    //钱海
//     public $admin_id = 613;

    //大王花
//     public $admin_id = 117197;

    //千米钱包
//     public $admin_id = 118367;

    //瑞丰米仓
//     public $admin_id = 115705;

    // 旺旺钱包
//     public $admin_id = 117580;

    //百鑫速贷
//     public $admin_id = 117521;

    //续借宝
//     public $admin_id = 117295;

    //任性钱包
//     public $admin_id = 113507;

    //爱钱站
//     public $admin_id = 113853;

    //够花花
//     public $admin_id = 3555;

    //融易借
//     public $admin_id = 118558;

    
//     欢乐用 
//     public $admin_id = 117381;

    //金花花
//     public $admin_id = 113364;

    //猪猪快钱
//     public $admin_id = 117550;
    
    //超有钱
//     public $admin_id = 117412;

    //贷上花
//     public $admin_id = 117797;

    //我我贷
//     public $admin_id = 2789;

    //开新花
//     public $admin_id = 118914;

    //钞快借贷
//     public $admin_id = 111170;
    
    //小优钱包	
//     public $admin_id = 118298;

    //花生钱包
//     public $admin_id = 117616;

    //七贝
//     public $admin_id = 117773;

//     天猫易贷
//     public $admin_id = 116942;

    //花新贷
//     public $admin_id = 116675;

    //秒速宝
//     public $admin_id = 1962;

    //米来
//     public $admin_id = 117808;

    //大花钱包
//     public $admin_id = 111428;

    //可劲花
//     public $admin_id = 114743;
    
    //七日钱包
//     public $admin_id = 111708;

    //火箭贷 	
//     public $admin_id = 3639;

    //好信贷
//     public $admin_id = 3635;

    //白鲸钱包
//     public $admin_id = 117642;
    
    //91金卡
//     public $admin_id = 117447;

    //花了没
//     public $admin_id = 118794;

//     钱小宝
//         public $admin_id = 117074;

    //快借钱包	
//     public $admin_id = 115690;

    //贷来钱
//     public $admin_id = 1565;
    
    //金银花
//     public $admin_id = 117690;

    //马上有钱
//     public $admin_id = 117348;

    //回360
//     public $admin_id = 2427;

    //e秒钱包
//     public $admin_id = 111584;

    //九富钱包  	
//     public $admin_id = 113850;

    //信任花
//     public $admin_id = 118523;
    
    //326-1有钱花
//     public $admin_id = 117103;
    
    //326-2快速花
//     public $admin_id = 2470;
    
    //326-3易速借
//     public $admin_id = 3248;
    
    //326-4融益花
//     public $admin_id = 1015;
    
    //326-5金有花
//     public $admin_id = 117240;

    //326-6钻石钱包
//     public $admin_id = 113646;
    
    //326-7速贷白条
//     public $admin_id = 112131;
    
    //326-8太好贷
//     public $admin_id = 2621;
    
    //326-9易到钱包
//     public $admin_id = 118582;

    //326-10祥腾宝
//     public $admin_id = 117101;

    //327-1天寿金 
//     public $admin_id = 114510;
    
    //327-2借快钱   	
//     public $admin_id = 117523;
    
    //327-3福贷钱包
//     public $admin_id = 116486;
    
    //327-4名扬钱庄
//     public $admin_id = 117679;
    
    //327-5安星花
//     public $admin_id = 115393;
    
    //327-6路人贷
//     public $admin_id = 114975;

    //327-7催收百分百
//     public $admin_id = 5;
    
    //328-1易贷钱包
//     public $admin_id = 118658;
    
    //328-2我来花 
//     public $admin_id = 114723;
    
    //328-3鸿盛钱包
//     public $admin_id = 117581;

    //328-4德立钱包
//     public $admin_id = 117375;

    //329-1我期贷 
//     public $admin_id = 28;
    
    //329-2速放
//     public $admin_id = 117635;
    
    //329-3八借钱包
//     public $admin_id = 112154;
     
    //329-4借款君
//     public $admin_id = 112494;

    //329-5钱给力   
//     public $admin_id = 113731;

    //329-6滴滴借钱
//     public $admin_id = 2989;

    //329-7秒给钱
//     public $admin_id = 614;

    //329-8先花呗
//     public $admin_id = 1494;
    
    //330-1网红贷
//     public $admin_id = 111949;

    //330-2给力花
//     public $admin_id = 455;

    //330-3易来钱 
//     public $admin_id = 368;

    //41-1飞速时代
//     public $admin_id = 118548;
    
    //41-2易顺钱包
//     public $admin_id = 113230;
    
    //41-3平安e贷
//     public $admin_id = 118094;

    //41-4全贷走
//     public $admin_id = 191;
    
    //41-5速贷呗
//     public $admin_id = 39;
    
    //41-6宜信快借
//     public $admin_id = 2310;

    //41-7云天贷
//     public $admin_id = 116532;
    
    //41-8量贩钱包
//     public $admin_id = 111657;
    
    //42-1今周转 
//     public $admin_id = 117414;
    
    //42-2鑫易钱包
//     public $admin_id = 111766;
    
    //42-313易到
//     public $admin_id = 119509;
    
    //42-4诚信金服
//     public $admin_id = 117685;
    
    //42-5速贷侠
//     public $admin_id = 1620;
    
    //42-6钱到手
//     public $admin_id = 117752;

    //42-7敬业贷
//     public $admin_id = 113643;
    
    //43-1吉米花
//     public $admin_id = 116291;
    
    //43-2享先花
//     public $admin_id = 119786;
    
    //43-3水牛花
//     public $admin_id = 113860;
    
    //44-1信和金融  
//     public $admin_id = 119665;
    
    //44-2鸿安金融
//     public $admin_id = 116974;
    
    //44-3天玑贷
//     public $admin_id = 118911;

    //44-4钱速借 
//     public $admin_id = 119794;
    
    //44-5聚信金
//     public $admin_id = 113963;
    
    //44-6易信金
//     public $admin_id = 113986;

    //49-1海鸥借呗
//     public $admin_id = 111350;
    
    //49-2富二贷  
//     public $admin_id = 118139;
    
    //49-3万隆金条
//     public $admin_id = 119361;
    
    //49-4柚分期 
//     public $admin_id = 114221;
    
    //49-5融易花  
//     public $admin_id = 118551;
    
    //410-1易秒花  
//     public $admin_id = 118207;
    
    //410-2早早贷 
//     public $admin_id = 117809;
    
    //410-3优选花  
//     public $admin_id = 119416;
    
    //410-4钱满多  117918
//     public $admin_id = 117918;
    
    //411-1企鹅贷
//     public $admin_id = 119692;
    
    //411-2你我速贷
//     public $admin_id = 113799;
    
    //411-3易恒钱包  
//     public $admin_id = 116017;
    
    //411-4钱袋袋
//     public $admin_id = 3655;

    //412-1秒借到  
//     public $admin_id = 1696;
    
    //415-1超级贷
//     public $admin_id = 117846;
    
    //415-2聚财宝
//     public $admin_id = 118549;
    
    //415-3百分百速贷
//     public $admin_id = 114693;
    
    //415-4火银贷
//     public $admin_id = 113818;
    
    //415-5米立方
//     public $admin_id = 119977;
    
    //416-1开心花呗
//     public $admin_id = 114779;
    
    //418-1直接贷
//     public $admin_id = 114587;
    
    //418-2小米粒
//     public $admin_id = 119617;

    //419-1多多米
//     public $admin_id = 119419;
    
    //419-2岁岁钱包
//     public $admin_id = 117774;
    
    //423-1桔速花
//     public $admin_id = 119785;
    
    //424-1大钱包
//     public $admin_id = 119307;
    
    //424-2海湖贷
//     public $admin_id = 116793;
    
    //425-1够花么
//     public $admin_id = 117543;
    
    //428-1米口袋
//     public $admin_id = 120235;
    
    //428-2来借点 
//     public $admin_id = 113228;
    
    //428-3你的钱包 
//     public $admin_id = 117198;
    
    //57-1贝壳应急
//     public $admin_id = 117814;
    
    //57-2花花牛
//     public $admin_id = 120192;
    
    //59-1易借钱包
//     public $admin_id = 116049;
    
    //5-11钱多多  
//     public $admin_id = 120279;
    
    //5-1491借呗
//     public $admin_id = 118625;
    
    //5-18卡卡分期  
//     public $admin_id = 117202;
    
    //5-21-1易顺钱包
//     public $admin_id = 113230;
    
    //5-21-2钱柜
//     public $admin_id = 120451;
    
    //5-22-1钱在线
//     public $admin_id = 120735;
    
    //5-22-2单车快钱
//     public $admin_id = 120470;
    
    //5-23-1星星钱包
//     public $admin_id = 120810;
    
    //5-25-1熊猫花花
//     public $admin_id = 120811;
    
    //5-25-2借一点
//     public $admin_id = 113556;
    
    //5-25-3小袋熊
//     public $admin_id = 120888;

    //5-27-1速放米
    //public $admin_id = 120722;
    
    //5-27-2钱力宝 
//     public $admin_id = 120812;
    
    //5-29-1招联秒借 
//     public $admin_id = 120906;

    //5-29-2创业钱包 
//     public $admin_id = 120259;
    
    //5-29-3龙王贷
//     public $admin_id = 120564;
    
    //5-29-460秒  
//     public $admin_id = 120709;
    
    //5-29-5小小钱袋  
//     public $admin_id = 120922;
    
    //5-30-1秒壹贷  
//     public $admin_id = 117583;
    
    //5-30-2神人易贷  
//     public $admin_id = 112949;

    //5-30-3一点E贷  
//     public $admin_id = 117839;
    
    //5-30-4金钱包  1711
//     public $admin_id = 1711;
    
    //5-30-5顺利贷  
//     public $admin_id = 119848;

    //重生宝  112592
//     public $admin_id = 112592;
    
    //5-31-1壹秒贷  
//     public $admin_id = 1314;
    
    //5-31-2放心花
//     public $admin_id = 121057;

    //5-31-3利丰钱包
//     public $admin_id = 115344;
    
    //5-31-4融创借呗
//     public $admin_id = 117740;
    
    //6-1-1金丝猴  
//     public $admin_id = 120910;
    
    
    //6-1-2万米钱包  
//     public $admin_id = 120949;
    
    
    //6-1-3备用金  
//     public $admin_id = 116837;
    
    
    //6-1-4闪贷 
//     public $admin_id =  119232;

    
    //6-1-5闪易借  
//     public $admin_id =  120003;
    
    //6-3-1掌上管家
//     public $admin_id =  117746;
    
    //6-3-2秒易钱包
//     public $admin_id =  117841;
    
    
    //6-3-3金牛易贷
//     public $admin_id =  120805;
    
    //6-3-4随心花
//     public $admin_id =  119102;
    
    //6-3-5贷你借
//     public $admin_id =  117176;
    
    //6-4-1点点借  112295
//     public $admin_id =  112295;
    
    //6-4-2米连花  
//     public $admin_id =  120202;
    
    //6-4-3薪动分期  
//     public $admin_id =  121182;
    
    //6-4-4魔法钱包  
//     public $admin_id =  120827;
    
    //6-4-5解囊相助
//     public $admin_id =  112422;
    
    //6-4-6演示版
//     public $admin_id =  755;
    
    //6-5-1融信宝  
//     public $admin_id =  120627;
    
    //6-5-2米花  
//     public $admin_id =  121179;
    
    //6-5-3小飞猪 
//     public $admin_id =  120347;
    
    //6-6-1微粒花  
//     public $admin_id =  111848;
    
    //6-6-2可以贷
//     public $admin_id =  115179;
    
    //6-6-3智慧钱包
//     public $admin_id =  120928;
    
    //6-6-4蚂蚁粮仓 
//     public $admin_id =  114725;

    //6-6-5喜羊羊钱包
    public $admin_id =  121166;
    
    
    //独立统计
    public function actionIndex()
    {
        
        $result = [];
        echo "\n---------------------------begin------------------------------------\n\n";
        foreach ($this->tables as $key => $val) {
            
            $count = (new \yii\db\Query())->from($val)->count();
            echo str_pad($key, 5, '-').str_pad($val, 50, '-').$count;
            echo "\n\n"; 
        }
        
        echo "\n---------------------------end--------------------------------------\n";
    }
    
    //联合统计
    public function actionIndex2()
    {
        //只读库
//         $db = new yii\db\Connection([
//             'dsn' => 'mysql:host=rr-bp10py0xbj3k4wcshuo.mysql.rds.aliyuncs.com;dbname=xindaishuju',
//             'username' => 'ecbumizde',
//             'password' => 'r9DExqjBGcsX&s5N',
//             'charset' => 'utf8',
//             'tablePrefix' => 'busy_'
//         ]);

        $db = new yii\db\Connection([
            'dsn' => 'mysql:host=rr-bp1x1q15h8955237mo.mysql.rds.aliyuncs.com;dbname=xindaishuju',
            'username' => 'r0q9h2i2g7j1d2e5',
            'password' => 'w&6Ju+1Ij$5Sa+4Fh(7Dd!5Sc$0Yo!1C',
            'charset' => 'utf8',
            'tablePrefix' => 'busy_'
        ]);
        
        $result = [];
        echo "\n---------------------------begin--------------------------------------------------------------------------\n\n";

        foreach ($this->tables as $key => $val) {
            //独立库数据
            $count = (new \yii\db\Query())->from($val)->count();
            
            //总库统计
            $count2 = '[*]';
            if (array_key_exists($val, $this->master)) {
                
                $sql = $this->master[$val];
                
                $count2 = $db->createCommand($sql)
                    ->bindValue(':admin_id', $this->admin_id)
                    ->queryOne();
                
                if ($count2) {
                    $count2 = $count2['count'];
                }
            }
            
            if ($count != $count2) {
                echo "[warning]";
            }
            echo str_pad($key, 5, '-').str_pad($val, 50, '-').str_pad($count, 15, '-').$count2;
            echo "\n\n";
        }
        
        $this->checkbusy_admin_product();
        
        echo "\n---------------------------end------------------------------------------------------------------------------\n";
        
    }
    
    /**
     * 
     * 1、获取总数
     * 2、判断是否有记录，是否继续往下执行
     * 3、计算分页
     * 4、获取数据
     * 5、获取表头
     * 6、组装数据
     * 5、成功之后，记录成功信息
     * 
     * 注：记录好表信息
     * 
     * @param string $table
     */
    public function actionMigrate($table)
    {
        //总概要信息[表名table,总数count,错误数, 成功数,错误id]
        $info = [];

        //每页数据
        $pageSize = 100;
        
        //当前页码
        $nowPage = 0;
        
        //总页数
        $pageTotal = 0;

        if (!array_key_exists($table, $this->master)) {
            die("table not exists\n");
        }
        
        if (!array_key_exists($table, $this->migrate)) {
            die($table."not migrate\n");
        }
        
        //master 数据库
//         $db = new yii\db\Connection([
//             'dsn' => 'mysql:host=rr-bp10py0xbj3k4wcshuo.mysql.rds.aliyuncs.com;dbname=xindaishuju',
//             'username' => 'ecbumizde',
//             'password' => 'r9DExqjBGcsX&s5N',
//             'charset' => 'utf8',
//             'tablePrefix' => 'busy_'
//         ]);
        
        $db = new yii\db\Connection([
            'dsn' => 'mysql:host=rr-bp1x1q15h8955237mo.mysql.rds.aliyuncs.com;dbname=xindaishuju',
            'username' => 'r0q9h2i2g7j1d2e5',
            'password' => 'w&6Ju+1Ij$5Sa+4Fh(7Dd!5Sc$0Yo!1C',
            'charset' => 'utf8',
            'tablePrefix' => 'busy_'
        ]);
        
        
        //计算总数
        $sql_total = $this->master[$table];
        $count = $db->createCommand($sql_total)->bindValue(':admin_id', $this->admin_id)->queryOne();

        if (!$count['count']) {
            die("无数据\n");
        }
        
        $info[$table]['count'] = $count['count'];
        $info[$table]['success'] = 0;
        
        //计算分页
        if ($pageTotal > $pageSize) {
            $pageTotal = ceil($info[$table]['count']/$pageSize);
        } else {
            $pageTotal = 1;
        }

        //获取数据
        
        //获取表头 独立表头
        $sql_column = "select COLUMN_NAME from information_schema.COLUMNS where table_name = :table_name";
        $columns = $db->createCommand($sql_column)->bindValue(':table_name', $table)->queryAll();
        $columns = array_column($columns, 'COLUMN_NAME');
        if (!$columns) {
            die("table filed column error\n");
        }

        $sql_data = $this->migrate[$table];
        for ($nowPage = 1; $nowPage <= $pageTotal; $nowPage++) {
            $offset = ($nowPage-1) * $pageSize;
            $data = $db->createCommand($sql_data)->bindValue(':admin_id', $this->admin_id)->queryAll();
            
            //组装数据
            foreach ($data as  $key => $val) {
                foreach ($columns as $column) {
                    $insert[$key][] = $val[$column];
                }
            }

            //插入到新库,返回受影响的记录
            $res = Yii::$app->db->createCommand()->batchInsert($table, $columns, $insert)->execute();
            
            if ($res) {
                $info[$table]['success'] = $info[$table]['success'] + $res;
            }
        }
       
        foreach ($info as $key => $val) {
            echo "\n table:".str_pad($key, 50, '-').'count:'.str_pad($val['count'], 20, '-').'success:'.$val['success']."\n";
        }
        

//         echo "run end\n";
        
    }
    
    public function actionTest($val)
    {
        
        
        
//         if (!array_key_exists($val, $this->migrate)) {
//             die("table not exists\n");
//         }
        
//         $sql = $this->migrate[$val];
//         $count2 = Yii::$app->db->createCommand($sql)
//             ->bindValue(':admin_id', $this->admin_id)
//             ->queryOne();
        
//         var_dump($count2);
        
    }
    
    public function actionManyMigrate()
    {
        
        $db = new yii\db\Connection([
            'dsn' => 'mysql:host=localhost;dbname=hello',
            'username' => 'root',
            'password' => 'root',
            'charset' => 'utf8',
            'tablePrefix' => 'busy_'
        ]);
        
        
//         $master = new yii\db\Connection([
//             'dsn' => 'mysql:host=rr-bp10py0xbj3k4wcshuo.mysql.rds.aliyuncs.com;dbname=xindaishuju',
//             'username' => 'ecbumizde',
//             'password' => 'r9DExqjBGcsX&s5N',
//             'charset' => 'utf8',
//             'tablePrefix' => 'busy_'
//         ]);
        
        $master = new yii\db\Connection([
            'dsn' => 'mysql:host=rr-bp1x1q15h8955237mo.mysql.rds.aliyuncs.com;dbname=xindaishuju',
            'username' => 'r0q9h2i2g7j1d2e5',
            'password' => 'w&6Ju+1Ij$5Sa+4Fh(7Dd!5Sc$0Yo!1C',
            'charset' => 'utf8',
            'tablePrefix' => 'busy_'
        ]);
        
        foreach ($this->tables as $table) {
            
            
            $sql_total = $this->master[$table];
            $count = $master->createCommand($sql_total)->bindValue(':admin_id', $this->admin_id)->queryOne();
            
            if (!$this->confirm("您确定运行[".$table."],总数".$count['count']." ?",true)) {
                $this->stdout("[".$table."] 不运行!\n\n");
                continue;
            }
            
            //验证是否导过
            $data = $db->createCommand('SELECT * FROM migrate_data_log WHERE tb=:tb AND admin_id=:admin_id')
                ->bindValue(':tb', $table)
                ->bindValue(':admin_id', $this->admin_id)
                ->queryOne();
            
            if ($data) {
                $this->stdout("[".$table."] already migrate!\n\n");
                continue;
            }
            
            //输出开始导出信息
            $this->stdout("[".$table."] begin\n");
            
            //记录迁移数据(不论成功失败，一旦记录，发生错误手动处理)
            $res = $db->createCommand()->insert('migrate_data_log', [
                'tb' => $table,
                'admin_id' => $this->admin_id,
            ])->execute();
            
            if (!$res) {
                $this->stdout("migrate_data_log write fail!\n\n");
                exit;
            }
            
            //开始导数据
            $this->actionMigrate($table);
            
            //输出结束导出信息
            $this->stdout("[".$table."] end\n\n");

        }
        
        
    }
    
    
    
    public function actionTest2()
    {
        
        $db = new yii\db\Connection([
            'dsn' => 'mysql:host=localhost;dbname=hello',
            'username' => 'root',
            'password' => 'root',
            'charset' => 'utf8',
            'tablePrefix' => 'busy_'
        ]);
        
        $table = 'busy_pay_sh_config';
        
        
        if (!$this->confirm("您确定运行[".$table."] ?")) {
            $this->stdout("thank you!");
            exit; 
        }
        
        //验证是否导过
        $data = $db->createCommand('SELECT * FROM migrate_data_log WHERE tb=:tb AND admin_id=:admin_id')
            ->bindValue(':tb', $table)
            ->bindValue(':admin_id', $this->admin_id)
            ->queryOne();
            
        if ($data) {
            $this->stdout("data already migrate!");
            exit; 
       }
       
        //输出开始导出信息
        $this->stdout("[".$table."] begin");
        
        //记录迁移数据(不论成功失败，一旦记录，发生错误手动处理)
       $res = $db->createCommand()->insert('migrate_data_log', [
           'tb' => $table,
           'admin_id' => $this->admin_id,
        ])->execute();
        
        if (!$res) {
            $this->stdout("migrate_data_log write fail!");
            exit;
        }

        //开始导数据
        $this->actionMigrate($table);
        
        //输出结束导出信息
        $this->stdout("[".$table."] end");
        
    } 
    
    
    public function checkbusy_admin_product()
    {

        $data = Yii::$app->db->createCommand('SELECT id,purviews FROM busy_admin_product WHERE peoduct_type = 1 ')->queryAll();
        
        if (empty($data)) {
            echo "busy_admin_product migrate fail empty\n";
            exit;
        }
        
        $check_result = 'success';
        $temp = [];
        
        foreach ($data as $item) {
            $temp = json_decode($item['purviews'], true);
            $len = count($temp);
            if ($len > 4) {
                $check_result = 'fail--'.$item['id'];
                break;
            }
        }
       
        if ($check_result == 'success') {
            echo "busy_admin_product migrate success\n";
        } else {
            echo "busy_admin_product migrate {$check_result} \n";
        }  
    }
    
    
    public function actionHelp()
    {

        $table = "busy_admin_transaction_extension";
        
        //总管理员
        $sql_admin = "SELECT count(*) as count FROM busy_admin_transaction_extension WHERE admin_id = :admin_id";
        
        //所有的(总的和子账号)
        $sql_total =  "SELECT count(*) as count FROM busy_admin_transaction_extension WHERE admin_id in (select id from busy_admin_user where cid = :admin_id) or admin_id = :admin_id";
        
        //总库链接
        $master = new yii\db\Connection([
            'dsn' => 'mysql:host=rr-bp1x1q15h8955237mo.mysql.rds.aliyuncs.com;dbname=xindaishuju',
            'username' => 'ecbumizde',
            'password' => 'r9DExqjBGcsX&s5N',
            'charset' => 'utf8',
            'tablePrefix' => 'busy_'
        ]);
        
        
        $all_count = $master->createCommand($sql_total)->bindValue(':admin_id', $this->admin_id)->queryOne();
        $admin_count = $master->createCommand($sql_admin)->bindValue(':admin_id', $this->admin_id)->queryOne();
        
        $duli_count = (new \yii\db\Query())->from($table)->count();
        
        if (!$this->confirm("您确定运行[".$table."],all_count:[".$all_count['count']."];admin_count:[".$admin_count['count']."];duli_count:[".$duli_count."];add:[".($all_count['count'] - $admin_count['count'])."]",true)) {
            $this->stdout("[".$table."] 不运行!\n\n");
            exit;
        }
        
        file_put_contents('./migrate_busy_admin_transaction_extension.txt', json_encode(['amdin_id'=>$this->admin_id])."\r",FILE_APPEND);
        $this->actionMigrate($table);

    }
    
    /**
     * 校验数据no
     */
    public function actionValidate($table = '')
    {
        if (empty($table)) {
            $this->stdout("[".$table."] 不运行!\n\n");
            exit;
        }
    }
    
    /**
     * 迁移一下通讯录
     */
    public function actionMemberPhone()
    {

        $total = 0;
        $json_encode_error = 0;
        $adderror = 0;
        $exists = 0;
        $error = 0;
        $success = 0;
        
        $master = new yii\db\Connection([
            'dsn' => 'mysql:host=rr-bp1x1q15h8955237mo.mysql.rds.aliyuncs.com;dbname=xindaishuju',
            'username' => 'r0q9h2i2g7j1d2e5',
            'password' => 'w&6Ju+1Ij$5Sa+4Fh(7Dd!5Sc$0Yo!1C',
            'charset' => 'utf8',
            'tablePrefix' => 'busy_'
        ]);
        
        
        $sql_total = "SELECT count(a.id) as count FROM busy_member_phone_m a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id=:admin_id ";//and a.create_time > '2019-05-23 20:00:00' 
        $count = $master->createCommand($sql_total)->bindValue(':admin_id', $this->admin_id)->queryOne();

        $total = $count['count'];

        //获取数据
        $sql_data = "SELECT a.* FROM busy_member_phone_m a left JOIN busy_member b on  a.id = b.id WHERE b.admin_id = :admin_id order by a.id asc";//and a.create_time > '2019-05-23 20:00:00'
        $data = $master->createCommand($sql_data)->bindValue(':admin_id', $this->admin_id)->queryAll();
        
        //链接mongodb
        $collection = Yii::$app->mongodb->getCollection ('busy_member_phone');
        
        foreach ($data as $key => $val) {
            
            echo $key . '--' . $val['id'] . "\r\n";
            
            $is_exists = (new \yii\db\Query())
                ->from('busy_member_phone')
                ->where(['id'=>$val['id']])
                ->one();
            
            if ($is_exists) {
                $exists++;
                continue;
            }

            $phone = $collection->findOne(['_id'=>$val['mongdb_id']],['phone']);
            //$phone['phone']
          
            //这个编辑错是什么
           $phone = json_encode($phone['phone']);
            
           if ($phone === false) {
               $json_encode_error++;
               continue;
           }

           //开始写入
            $res = Yii::$app->db->createCommand()->insert('busy_member_phone', [
                'id' => $val['id'],
                'phone' => $phone,
                'create_time' => time()
            ])->execute();
            
            if ($res === false) {
                $adderror++;
                continue;
            }
            
            $success++;
            
            var_dump(json_encode(['date'=>$val,'res'=>$res]));
            
           //读取测试
//            $res = Yii::$app->db->createCommand('SELECT * FROM busy_member_phone WHERE id = 8705544')->queryOne();
//            var_dump($res);

            
        }
        
        
        echo "total:".$total . '---success:'.$success.'---exists:'.$exists.'---json_encode_error:'.$json_encode_error.'---adderror:'.$adderror."\r\n";

        
        
        
        
        
        
    }
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
}